Effective dating
Snapshots
Automation
User friendly interface
But CUNY First has effective dates
Many CUNY First tables don’t have effective dates
class section data
changes in status
changes in capacity
Very few tables have effective end dates
Effective end dates are inconsistent
Create end dates for effective dated fields
Create deleted status for deleted fields
Generate effective dates where previously nonexistant
Historical static views of CUNY First at specified points in history
IT has this all set up automatically
The reporting instance query
Extraction from tumbleweed
The effective dating
The snapshots
OBIEE web app interface
Abstracts away leftover complexity of datawarehouse
No SQL required
Drag and drop gui